Entity Relationships - Trainee Basic Details (TRAINEE)

The TRAINEE table stores basic details about trainees, such as name, date of birth, address, contact details, etc.

Related Tables

Table Name	Table Description	Primary Keys	Usually Joins From	Join Type	Joins On	Details
TRAINEEPOT	Trainee Period of Training	TRAINEEID, POT	TRAINEE	One to many	TRAINEEID	Stores data for a specific period of training (POT), such as start date, termination date and contractor.
TRAINEEPOT2	Trainee POT Details 2	TRAINEEID, POT	TRAINEEPOT	One to one	TRAINEEID, POT	An extension of TRAINEEPOT data.
TRAINEEINFO	Trainee Misc. Info	TRAINEEID	TRAINEE	One to one	TRAINEEID	Stores additional non-POT specific trainee data.
TRAINEEDETAILS	Trainee Trackable Info	TRAINEEID, Q_DETAILID	TRAINEEPOT	One to many	TRAINEEID, POT	Stores trackable, POT-specific data, such as aim reference and disability status.
TRAINEE_ILR_AIMS	ILR Subsidiary Aims	TRAINEEID, POT, AIMNO	TRAINEEPOT	One to many	TRAINEEID, POT	Stores ILR sub-aims.
TRAINEE_LLWR_ACT	LLWR Activities	TRAINEEID, POT, LACTI_ID	TRAINEEPOT	One to many	TRAINEEID, POT	Stores LLWR activities.
TRAINEE_LLWR_AWARD	LLWR Awards	TRAINEEID, POT, AWARD_NO	TRAINEE_LLWR_ACT	One to one	TRAINEEID, POT, LACTI_ID (to LACTLINK)	Stores LLWR awards.
CLAIMDETAILS	Claim Details	CLAIMDETAILID, CLAIMID, CONTRACTID	TRAINEEPOT, TRAINEEDETAILS	One to many	TRAINEEID, POT, CONTRACTORID, NVQREF	Stores claim rows generated from profile measurements.
TRASSESSOR	Trainee-Assessor Link	TRAINEEID, TRASSID	TRAINEE	One to many	TRAINEEID	Table which links trainees to assessors.
TREMPLOYER	Trainee-Employer Link	TRAINEEID, TREMPID	TRAINEE	One to many	TRAINEEID	Table which links trainees to employers.
TRMODULE	Trainee Modules	TRAINEEID, MODCODE (foreign key), TRMODULEID	TRAINEE	One to many	TRAINEEID	Table which links trainees to objectives.
TRVISIT	Trainee Visits	TRAINEEID, VISID	TRAINEE	One to many	TRAINEEID	Table which links trainees to visits.
TRCOURSES	Trainee Courses	TRCOURSEID	TRAINEE	One to many	TRAINEEID	Table which links trainees to courses.